package xnyrpt

import com.tsqc.system.util.table.TranposUtils

import java.text.SimpleDateFormat

class PicklingSPController {
    def dynamicQueryService

    def picklingSP() {
        def pageCurrent = params.pageCurrent ? Integer.parseInt(params.pageCurrent) : 1
        def pageSize = params.pageSize ? Integer.parseInt(params.pageSize) : 10
        params.startno = (pageSize * (pageCurrent - 1)) + 1
        params.endno = pageSize * pageCurrent
        SimpleDateFormat sdf = new SimpleDateFormat('yyyy-MM')
        def startTime = params.startTime ? sdf.parse(params.startTime) : sdf.parse(sdf.format(new Date().clearTime()))
        def endTime = params.endTime ? sdf.parse(params.endTime) : sdf.parse(sdf.format(new Date().clearTime() - 1))
        params.startTime = sdf.format(startTime)
        params.endTime = sdf.format(endTime)
        def tableHeadList = []
        def picklingSP = []
        def pageSizeList = [10, 20, 50, 100]
        def totalCount = 0
        if (params.EXPORT_CONTENT_NAME == 'Excel') {
            params.SYS_QUERY_NAME = 'picklingSP'
            picklingSP = dynamicQueryService.queryForList(params)
            if(picklingSP.size()>0) {
                tableHeadList = picklingSP[0].keySet()
            }
        }

        [startno      : params.startno ?: '',
         endno        : params.endno ?: '',
         pageSize     : pageSize,
         totalCount   : totalCount,
         pageSizeList : pageSizeList,
         tableHeadList: tableHeadList,
         picklingSP   : picklingSP,
         startTime    : params.startTime ?: '',
         endTime      : params.endTime ?: '',
         partName     : params.partName ?: '',
         tuhao        : params.tuhao ?: '',
         startDocId   : params.startDocId ?: '',
         endDocId     : params.endDocId ?: '',
         eqp          : params.eqp ?: ''
        ]
    }

    def exportExcel() {
        def sysQueryName


        sysQueryName = params.SYS_QUERY_NAME

        params.startno = 1
        params.endno = 99999999999999999
        params.SYS_QUERY_NAME = sysQueryName

        def dataList = dynamicQueryService.queryForList(params)
        def tableHeadList = []
        if (sysQueryName == 'picQQklingSP') {
            dataList = TranposUtils.colToRow('HOUR', 'SL', dataList)
            println(dataList)
        }
        if (dataList.size() > 0) {
            tableHeadList = dataList[0].keySet()
        }
        String fileName = new String("${sysQueryName}.xls".getBytes("UTF-8"), "UTF-8");
        response.setContentType('application/vnd.ms-excel;charset=UTF-8')
        response.setHeader('Content-disposition', "attachment;filename=${fileName};charset=UTF-8")
        response.setCharacterEncoding("UTF-8");
        render(template: "export${params.EXPORT_CONTENT_NAME}", model: [dataList: dataList, tableHeadList: tableHeadList, startno: params.startno ?: '', endno: params.endno ?: ''])
    }
}